- Starting Date: Enquire About It
- Timings: Flexible options
Course details
Ministry Approved Certificate
Course Overview
(PL/SQL, Workshop I & Workshop II)
Oracle 10g- Introduction to SQL and PL/SQL
Course Contents:
- Introduction
- Retrieving Data Using the SQL SELECT Statement
- Restricting and Sorting Data
- Using Single Row Functions to Customize Reports
- Reporting Aggregated Data Using the Group Functions
- Displaying Data From Multiple Tables
- Using Sub queries to Solve Queries
- Using the SET Operators
- Manipulating Data
- Using DDL Statements to Create and Manage Tables
- Creating Other Schema Objects
- Managing Objects with Data Dictionary Views
- Controlling User Access
- Generating Reports by Grouping Related Data
- Managing Data in Different Time Zones
- Searching Data Using Advanced Sub queries
- Hierarchical Data Retrieval
- Introduction to PL/SQL Objects
- Procedural Language
- PL/SQL Blocks, Anonymous Blocks and Named Blocks
- Creating PL/SQL Procedures and Functions
- Understanding Triggers
- Packages
Oracle 10g-Administration Workshop I
Course Contents:
- Introduction
- Installing Oracle Database 10g Software
- Create an Oracle Database
- Database interfaces
- Controlling the database
- Storage Structures
- Administering users
- Managing Schema Objects
- Managing Data
- PL/SQL
- Oracle Database Security
- Oracle Net Services
- Oracle Shared Server
- Performance Monitoring
- Proactive Maintenance: Objectives Undo Management
- Monitoring and Resolving Lock Conflicts
- Backup and Recovery Concepts
- Database Backups
- Database Recovery
Oracle 10g-Administration Workshop II
Course Contents:
- Using Globalization Support
- Securing the Oracle Listener
- Configuring Recovery Manager
- Using Recovery Manager
- Diagnostic Sources
- Recovering from non-critical losses
- Database Recovery
- Flashback database
- Recovering from User Errors
- Dealing with Database Corruption
- Automatic Database Management
- Monitoring and Managing Storage
- Automatic Storage Management
- Monitoring and Managing Memory
- Managing Resources
- Automating Tasks with the Scheduler
About Aptech Computer Training
Jurassic Institute of Management and Technology is a Learning Solutions Company playing a key role in helping individuals, organizations and nations adapt to the changing requirements of a knowledge-driven world. Jurassic commenced its IT and NON IT Education & Training business in 1993 in UAE. Jurassic is the franchisees of the brand Aptech Computer Education, Arena Multimedia and English Express in UAE. Aptech Computer Education, a division of Aptech Limited has over 3,256 training centers in 56 countries. Arena Multimedia - Global Multimedia Education, leading the way in Multimedia Training has trained over 4,00,000 students.
See all Aptech Computer Training coursesYou may add more courses here,
your list will be saved.
